Import, Export or Verify AFD Address Data

You can export address data and then use the AFD Refiner tool to ensure that address data is accurate, before reimporting.

You can manage address data in the following ways:

You can export address data to improve address information or append geodemographic data.

To export address data:

  1. Click the Data Miner button on the Reporting ribbon.

    Reporting ribbon Data Miner button

  2. Expand the Learner section of Application Contexts, and then select the Learner Addresses option.

    Select Learner Addresses from Application Contexts

  3. Choose AFD Export from the drop-down list to enable the relevant columns for export. Use the Condition Builder to filter search results.

    AFD Export drop-down

    Note: You must choose AFD Export option from the drop-down list to ensure that the relevant columns are available for export.

  4. Right click a record in the grid, and select Export Data from the menu.

    Select Export Data from the Condition Builder

    The Export Settings window is displayed.

    Export Settings

The export settings options are described in the following table.

This field Holds this information...
Save Export To

The file path that the export file should be saved to.

Note: Click the Browse button to browse to the required file path.
Data Selection The data that is exported from the grid. Select All Rows or Selected.
Export Type

The export type. Select from the following:

  • Raw Data (Fast)
  • Formatted Data
Export Format The export format. Select from the following:
  • Excel 97-2003 (.XLS) Format (limited to 65000 rows)
  • Excel 2007+ (.XLSX) Format
  • Comma Separated Value (.CSV) Format
Include Query Information Whether to include query information on the export.
Include SQL Query Whether to include the sql query information on the export.
Apply Styling Whether styling is required on the export.
Include Group Colours Whether group colours are required on the export.
Open File after Export Whether to open the file automatically after it has been exported.

  1. Click OK to export.

    The Export Status window is displayed.

    Export Status window

    Note: If required, you can click the Cancel button to cancel the export.

The data is exported to the selected file location and displayed in the selected format.

Back to top

You can use AFD Refiner to assess the accuracy of the address data.

Refer to the Refiner page on the AFD website for further information.

Data is validated by the import process before importing to ensure that addresses are excluded if:

  • The address does not exist
  • The first line of the address is missing

Note: The import filename must begin with 'AddressImport'. Digits may also be appended to the filename to indicate a date (for example: AddressImport20171214).

To import address data:

  1. Click the Imports button on the System ribbon.

    System ribbon Imports button

  2. Click the Open File button on the Admin Commands ribbon

    Admin Commands ribbon Open File button

    The Open window is displayed.

    Select file from Windows Explorer

  3. Select the file that you want to import and click Open.

On completion, addresses are displayed in the grid with new values replacing existing fields. Geodemographic data classifying the economic and demographic characteristics of the population is added wherever it was missing.

A yellow cell indicates that the content has been amended since the export. Hovering your mouse over a yellow cell displays a tooltip providing more information about the change.

Condition Builder changed cells

Back to top